package com.rfsp.mcp.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.rfsp.common.base.BaseMapper;
import com.rfsp.mcp.pojo.po.OrgSjjPO;
import org.springframework.stereotype.Repository;

@Repository
public interface OrgSjjMapper extends BaseMapper<OrgSjjPO> {
	
	
	@Select("SELECT * FROM MCP_ORG_SJJ WHERE ORG_ID = #{orgId} ORDER BY ID DESC")
	List<OrgSjjPO> getSjjByOrgId(@Param("orgId") Long orgId);
}